DELETE FROM C1_ROLE_PERMISSION T WHERE INSTR(','||:roleIds||',', ','||T.ROLE_ID||',') > 0